package com.ioftv.dto;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import lombok.Data;

import java.io.Serializable;
import java.math.BigDecimal;

/**
 * 业务统计Excel导入导出DTO
 */
@Data
public class BusinessStatisticsExcelDTO implements Serializable {

    private static final long serialVersionUID = 1L;

    /**
     * 统计日期
     */
    @ExcelProperty(value = "统计日期(格式:2025-01-15)", index = 0)
    @DateTimeFormat("yyyy-MM-dd")
    private String statDate;

    /**
     * 企业总数
     */
    @ExcelProperty(value = "企业总数", index = 1)
    private Integer totalNum;

    /**
     * 订单总数
     */
    @ExcelProperty(value = "订单总数", index = 2)
    private Integer orderNum;

    /**
     * 收款总数（单位：元）
     */
    @ExcelProperty(value = "收款总数(元)", index = 3)
    private Long receivableNum;

    /**
     * 付款总数（单位：元）
     */
    @ExcelProperty(value = "付款总数(元)", index = 4)
    private Long paymentNum;

    /**
     * 试标人数
     */
    @ExcelProperty(value = "试标人数", index = 5)
    private Integer testPersonNum;

    /**
     * 质检人数
     */
    @ExcelProperty(value = "质检人数", index = 6)
    private Integer qcPersonNum;

    /**
     * 质检通过率（0-100）
     */
    @ExcelProperty(value = "质检通过率(填数字,如:95.5)", index = 7)
    private BigDecimal qcPassRate;
}
